Ì i 2
auto.letter.dates
[auto.letter.date]
*(YD)YMALA[ymaAD]
Field Name Len Dat Typ J DPM Offset/Local/VAL
auto.letter.date 8 DATE L ymaAD
auto.letter.date.active 1 YN L *(YD)YMALA[ymaAD]|0
Ì € i 2
auto.letters
[auto.letter.date, auto.letter.q]
*(YD)YMALA[ymaAD,ymaAQ]
Field Name Len Dat Typ J DPM Offset/Local/VAL
auto.letter.q 8 PINT R ymaAQ
auto.letter 10 FREE L MC.LETTER.TEXT *(YD)YMALA[ymaAD,ymaAQ]|0
auto.letter.member 25 URN L MC.MEM *(YD)YMALA[ymaAD,ymaAQ]|1
Ì i 2
merge.history
[merge.seconds,merge.type]
*(YD)YMAMXQ[ymaMX,ymaMT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
merge.seconds 10 FREE L ymaMX
merge.type 7 FREE L ymaMT
merge.adm.xfer.seq 50 FREE L *(YD)YMAMXQ[ymaMX,ymaMT]|2
merge.from.mpi 25 URN L MRI.PAT *(YD)YMAMXQ[ymaMX,ymaMT]|3
merge.from.or.to 5 CHOICE L
merge.from.unit.num 10 FREE L *(YD)YMAMXQ[ymaMX,ymaMT]|5
merge.from.urn 25 URN L MC.MEM *(YD)YMAMXQ[ymaMX,ymaMT]|0
merge.to.mpi 25 URN L MRI.PAT *(YD)YMAMXQ[ymaMX,ymaMT]|4
merge.to.unit.num 10 FREE L *(YD)YMAMXQ[ymaMX,ymaMT]|6
merge.to.urn 25 URN L MC.MEM *(YD)YMAMXQ[ymaMX,ymaMT]|1
Ì € i 2
merge.errors
[merge.seconds,merge.type, merge.error.queue]
*(YD)YMAMXQ[ymaMX,ymaMT]ERR[ymaME]
Field Name Len Dat Typ J DPM Offset/Local/VAL
merge.error.queue 5 INT R ymaME
merge.error.text 79 FREE L *(YD)YMAMXQ[ymaMX,ymaMT]ERR[ymaME]|0
Ì € i 2
merge.log
[merge.seconds,merge.type, merge.log.queue]
*(YD)YMAMXQ[ymaMX,ymaMT]LOG[ymaML]
Field Name Len Dat Typ J DPM Offset/Local/VAL
merge.log.queue 5 INT R ymaML
merge.log.text 79 FREE L *(YD)YMAMXQ[ymaMX,ymaMT]LOG[ymaML]|0
Ì i 2
process.rem.statuses
[pm.rem.status]
/YMAP["RS",ymaRS]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pm.rem.status 8 FREE L ymaRS
Ì i 2
process.task.statuses
[pm.task.status]
/YMAP["TS",ymaTS]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pm.task.status 8 FREE L ymaTS
Ì i 2
services.group.report.x
[sgr.mem.urn,sgr.index1,sgr.index2,sgr.index3]
/YMASGX[yma,gsh,gsd,ymaPD]
Field Name Len Dat Typ J DPM Offset/Local/VAL
sgr.mem.urn 25 URN L MC.MEM yma
sgr.index1 10 FREE L MIS.SVC.GRP gsh
sgr.index2 10 FREE L MIS.ABS.SVC gsd
sgr.index3 8 DATE L ymaPD
services.group.rpt.oop 10 MONEY R /YMASGX[yma,gsh,gsd,ymaPD]|2
services.group.rpt.qty 4 INT R /YMASGX[yma,gsh,gsd,ymaPD]|0
services.group.rpt.reimb 10 MONEY R /YMASGX[yma,gsh,gsd,ymaPD]|1
Ì i 2
top
[urn]
$(YM)YMA[yma]
Field Name Len Dat Typ J DPM Offset/Local/VAL
urn 25 URN L yma
alt.mri.database 12 FREE L MIS.APPL.DB
alt.mri.urn 25 URN L MRI.PAT
aud.birthdate 10 BDATE L $(YM)YMA[yma]A|6
aud.sex 1 CHOICE L $(YM)YMA[yma]A|7
birthdate 10 BDATE L VAL=@MRI.PAT.birthdate[@mpi]
city 20 FREE L VAL=@MRI.DRC.pat.city[@mpi]
city.state.zip 32 FREE L VAL=IF{L(@MRI.DRC.pat.city[@mpi]^ZMC)+L(IF{@MRI.DRC.pa
VAL=t.zip[@mpi]^XX ", "_XX}_IF{@MRI.DRC.pat.state[@mpi
VAL=]^XX " "_XX}^ZMSZ)>32 ZMC$(32-L(ZMSZ))_ZMSZ;ZMC
VAL=_ZMSZ}
current.age 7 FREE L VAL=%Z.age(@birthdate[@mpi])
disp.birthdate 10 BDATE L VAL=@Temp.record(EA,@MRI.PAT.birthdate)
disp.city 20 FREE L VAL=@Temp.record(AA,@MRI.DRC.pat.city)
disp.current.age 7 FREE L VAL=%Z.age(@disp.birthdate)
disp.emp.status 10 FREE L MIS.EMP.STATUS VAL=@Temp.record(YM,@emp.status)
disp.employer 30 FREE L MIS.EMPLR VAL=@Temp.record(AA,@MRI.DRC.employer)
disp.home.phone 18 PHONE L VAL=@Temp.record(AA,@MRI.DRC.pat.home.phone)
disp.marital.status 10 FREE L MIS.MAR.STATUS VAL=@Temp.record(AA,@MRI.DRC.marital.status)
disp.other.maid.name 30 FREE L VAL=@Temp.record(EA,@MRI.PAT.maiden.other.name)
disp.sex 1 CHOICE L VAL=@Temp.record(EA,@MRI.PAT.sex)
disp.soc.sec.num 12 FREE L VAL=@Temp.record(YM,@soc.sec.num)
disp.state 2 FREE L VAL=@Temp.record(AA,@MRI.DRC.pat.state)
disp.street 30 FREE L VAL=@Temp.record(AA,@MRI.DRC.pat.street)
disp.street2 30 FREE L VAL=@Temp.record(AA,@MRI.DRC.pat.street2)
disp.unit.number 10 FREE L VAL=@Temp.record(EA,@MRI.PAT.px.unit.number[,@.mri.pfx
VAL=])
disp.work.phone 18 PHONE L VAL=@Temp.record(AA,@MRI.DRC.emp.phone)
disp.zip 10 FREE L VAL=@Temp.record(AA,@MRI.DRC.pat.zip)
emp.status 10 FREE L MIS.EMP.STATUS $(YM)YMA[yma]A|4
employer 10 FREE L MIS.EMPLR VAL=@MRI.DRC.employer[@mpi]
home.phone 18 PHONE L VAL=@MRI.DRC.pat.home.phone[@mpi]
id 57 URN L VAL=(@mi.policy.number_" "_@name:0S)
id.name 30 URN L VAL=@name
last.mc.demo.edit 8 DATE L $(YM)YMA[yma]A|8
last.mc.edit 8 DATE L $(YM)YMA[yma]A|9
last.mc.ins.edit 8 DATE L $(YM)YMA[yma]A|10
marital.status 10 FREE L MIS.MAR.STATUS VAL=@MRI.DRC.marital.status[@mpi]
member 25 URN L
member.cd.screen 15 FREE L MIS.SCREEN VAL=@MC.PARAM.mem.cd.screen
merged.to 25 URN L MC.MEM $(YM)YMA[yma]A|11
mpi 25 URN L MRI.PAT $(YM)YMA[yma]A|0
mri.subscriber 35 URN L MRI.SUBSCRIBER $(YM)YMA[yma]A|12
mri.subscriber.db 12 FREE L MIS.APPL.DB $(YM)YMA[yma]A|13
name 30 NAME L $(YM)YMA[yma]A|1
new.member 25 URN L
other.maid.name 30 FREE L VAL=@MRI.PAT.maiden.other.name[@mpi]
pri.ins.plan 10 FREE L MC.MEM.PLAN $(YM)YMA[yma]A|3
sex 1 CHOICE L VAL=@MRI.PAT.sex[@mpi]
soc.sec.num 12 FREE L $(YM)YMA[yma]A|2
state 2 FREE L VAL=@MRI.DRC.pat.state[@mpi]
street 30 FREE L VAL=@MRI.DRC.pat.street[@mpi]
street2 30 FREE L VAL=@MRI.DRC.pat.street2[@mpi]
student.yn 1 YN L $(YM)YMA[yma]A|5
subscriber 25 URN L
unit.number 10 FREE L VAL=@MRI.PAT.px.unit.number[@mpi,@.mri.pfx]
urn.main 25 URN L
work.phone 18 PHONE L VAL=@MRI.DRC.emp.phone[@mpi]
zip 10 ZIP.POST L MIS.ZIP VAL=@MRI.DRC.pat.zip[@mpi]
Ì € i 2
authorized.services
[urn, auth.date,auth.svc.grp]
$(YM)YMA[yma]S[yadt,gsh]
Field Name Len Dat Typ J DPM Offset/Local/VAL
auth.date 8 DATE L yadt
auth.svc.grp 10 FREE L MIS.SVC.GRP gsh
auth.pri.qty 5 PINT R $(YM)YMA[yma]S[yadt,gsh]|1
auth.svc.grp.qty 5 PINT R $(YM)YMA[yma]S[yadt,gsh]|0
Ì € i 2
authorized.services.spec
[urn,auth.date,auth.svc.grp, auth.specialty]
$(YM)YMA[yma]S[yadt,gsh]S[gsd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
auth.specialty 10 FREE L MIS.ABS.SVC gsd
auth.specialty.qty 5 PINT R $(YM)YMA[yma]S[yadt,gsh]S[gsd]|0
Ì € i 2
authorized.svcs.by.month
[urn, auth.month,auth.mon.svc.grp]
$(YM)YMA[yma]M[yamon,gsh]
Field Name Len Dat Typ J DPM Offset/Local/VAL
auth.month 10 DATE L yamon
auth.mon.svc.grp 10 FREE L MIS.SVC.GRP gsh
auth.mon.pri.qty 5 PINT R $(YM)YMA[yma]M[yamon,gsh]|1
auth.mon.svc.grp.qty 5 PINT R $(YM)YMA[yma]M[yamon,gsh]|0
Ì € i 2
authorized.svcs.mon.spec
[urn,auth.month,auth.mon.svc.grp, auth.mon.specialty]
$(YM)YMA[yma]M[yamon,gsh]S[gsd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
auth.mon.specialty 10 FREE L MIS.ABS.SVC gsd
auth.mon.specialty.qty 5 PINT R $(YM)YMA[yma]M[yamon,gsh]S[gsd]|0
Ì € i 2
comments
[urn, comment.number]
$(YM)YMA[yma]C[ymaCN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
comment.number 3 PINT R ymaCN
com.last.edit.date 8 DATE L $(YM)YMA[yma]C[ymaCN]|4
com.last.edit.time 4 HHMM L $(YM)YMA[yma]C[ymaCN]|5
com.last.edit.txn.queue 3 PINT R $(YM)YMA[yma]C[ymaCN]|6
com.txn.date 8 DATE L $(YM)YMA[yma]C[ymaCN]|0
com.txn.queue 3 PINT R $(YM)YMA[yma]C[ymaCN]|2
com.txn.time 4 HHMM L $(YM)YMA[yma]C[ymaCN]|1
comment.subject 35 FREE L $(YM)YMA[yma]C[ymaCN]|3
Ì € i 2
key.field.audit
[urn, kf.aud.edit.date,kf.aud.seq.n]
$(YM)YMA[yma]AU[ymaed,ymasn]
Field Name Len Dat Typ J DPM Offset/Local/VAL
kf.aud.edit.date 8 DATE L ymaed
kf.aud.seq.n 4 PINT R ymasn
kf.ed.bdate.new 10 BDATE L $(YM)YMA[yma]AU[ymaed,ymasn]D|4
kf.ed.bdate.old 10 BDATE L $(YM)YMA[yma]AU[ymaed,ymasn]D|5
kf.ed.name.new 30 FREE L $(YM)YMA[yma]AU[ymaed,ymasn]D|0
kf.ed.name.old 30 FREE L $(YM)YMA[yma]AU[ymaed,ymasn]D|1
kf.ed.sex.new 1 FREE L $(YM)YMA[yma]AU[ymaed,ymasn]D|6
kf.ed.sex.old 1 FREE L $(YM)YMA[yma]AU[ymaed,ymasn]D|7
kf.ed.soc.sec.new 12 FREE L $(YM)YMA[yma]AU[ymaed,ymasn]D|2
kf.ed.soc.sec.old 12 FREE L $(YM)YMA[yma]AU[ymaed,ymasn]D|3
kf.edit.bdate 1 YN L $(YM)YMA[yma]AU[ymaed,ymasn]|4
kf.edit.name 1 YN L $(YM)YMA[yma]AU[ymaed,ymasn]|2
kf.edit.sex 1 YN L $(YM)YMA[yma]AU[ymaed,ymasn]|5
kf.edit.soc.sec 1 YN L $(YM)YMA[yma]AU[ymaed,ymasn]|3
kf.edit.source 50 FREE L $(YM)YMA[yma]AU[ymaed,ymasn]|0
kf.edit.user 10 FREE L $(YM)YMA[yma]AU[ymaed,ymasn]|1
Ì € i 2
additional.mpi
[urn, other.mpi]
$(YM)YMA[yma]A["MRI",ea]
Field Name Len Dat Typ J DPM Offset/Local/VAL
other.mpi 25 URN L MRI.PAT ea
Ì € i 2
benefit.totals
[urn, bene.mem.plan]
$(YM)YMA[yma]A["B",ymp]
Field Name Len Dat Typ J DPM Offset/Local/VAL
bene.mem.plan 10 FREE L MC.MEM.PLAN ymp
bene.reimb.in 9 MONEY R $(YM)YMA[yma]A["B",ymp]|0
bene.reimb.out 9 MONEY R $(YM)YMA[yma]A["B",ymp]|1
Ì € i 2
benefit.year.amounts
[urn,bene.mem.plan, benefit.year]
$(YM)YMA[yma]A["B",ymp,ymaY]
Field Name Len Dat Typ J DPM Offset/Local/VAL
benefit.year 4 YEAR L ymaY
bene.ded.in 9 MONEY R $(YM)YMA[yma]A["B",ymp,ymaY]|3
bene.ded.out 9 MONEY R $(YM)YMA[yma]A["B",ymp,ymaY]|4
bene.oop.in 9 MONEY R $(YM)YMA[yma]A["B",ymp,ymaY]|5
bene.oop.out 9 MONEY R $(YM)YMA[yma]A["B",ymp,ymaY]|6
bene.year.end 8 DATE L $(YM)YMA[yma]A["B",ymp,ymaY]|1
bene.year.start 8 DATE L $(YM)YMA[yma]A["B",ymp,ymaY]|0
Ì € i 2
insurance.plan
[urn, ins.plan]
$(YM)YMA[yma]A["I",ymp]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ins.plan 10 FREE L MC.MEM.PLAN ymp
benefit 10 FREE L MIS.INS.BENE $(YM)YMA[yma]A["I",ymp]|12
benefit.product 3 FREE L VAL=@MIS.INS.BENE.product.type[@benefit]
care.group 10 URN L MC.CARE.GRP $(YM)YMA[yma]A["I",ymp]|5
contract.employer 10 FREE L MIS.EMPLR VAL=@subs.contract.employer[@subscriber.urn,@ins.plan]
eff.dt.benefit 8 DATE L $(YM)YMA[yma]A["I",ymp]|13
eff.dt.cg 8 DATE L $(YM)YMA[yma]A["I",ymp]|10
eff.dt.ins.plan.status 8 DATE L $(YM)YMA[yma]A["I",ymp]|11
eff.dt.obgyn.pcp 8 DATE L $(YM)YMA[yma]A["I",ymp]|15
eff.dt.pcp 8 DATE L $(YM)YMA[yma]A["I",ymp]|9
group.number 15 FREE L VAL=@subs.iplan.grp.number[@subscriber.urn,@ins.plan]
hold.from.adj 1 YN L $(YM)YMA[yma]A["I",ymp]I2|0
hold.from.adj.date.out 12 FREE L VAL=%Z.date.text(%Z.date.in.magic(@hold.from.adj.time)
VAL=,"m d, Y")
hold.from.adj.reason 20 FREE L $(YM)YMA[yma]A["I",ymp]I2|1
hold.from.adj.time 10 PINT R $(YM)YMA[yma]A["I",ymp]I2|3
hold.from.adj.time.out 8 FREE L VAL=%Z.time.text(@hold.from.adj.time,"h:M A")
hold.from.adj.user 10 FREE L UNV.USER $(YM)YMA[yma]A["I",ymp]I2|2
hold.from.adj.user.out 20 FREE L VAL=@UNV.USER.name[@hold.from.adj.user]
hold.from.adj.yn 1 YN L VAL=IF{@hold.from.adj;@ins.plan "N"}
ins.plan.exp.date 8 DATE L VAL=@subs.iplan.exp.date[@subscriber.urn,@ins.plan]
ins.plan.renew.date 8 DATE L VAL=@subs.iplan.renew.date[@subscriber.urn,@ins.plan]
ins.plan.status 9 CHOICE L $(YM)YMA[yma]A["I",ymp]|3
ins.plan.sub.eff.date 8 DATE L VAL=@eff.dt.ins.plan.status[@subscriber.urn,@ins.plan]
ins.plan.sub.status 9 FREE L VAL=@ins.plan.status[@subscriber.urn,@ins.plan]
ins.plan.type 10 FREE L VAL=@subs.iplan.type[@subscriber.urn,@ins.plan]
insurance.plan.cd.screen 15 FREE L MIS.SCREEN VAL=@MC.MEM.PLAN.insurance.cd.screen[@ins.plan]
member.card.printed 1 YN L $(YM)YMA[yma]A["I",ymp]|16
member.card.printed.on 8 DATE L $(YM)YMA[yma]A["I",ymp]|17
member.card.printed.yn 1 YN L VAL=IF{@member.card.printed;@ins.plan "N"}
member.id 25 FREE L
member.number 25 FREE L $(YM)YMA[yma]A["I",ymp]|0
member.number.base 22 FREE L $(YM)YMA[yma]A["I",ymp]|8
member.number.px 3 FREE L $(YM)YMA[yma]A["I",ymp]|7
obgyn.pcp 10 FREE L MC.PROV.CON $(YM)YMA[yma]A["I",ymp]|14
pcp 10 FREE L MC.PROV.CON $(YM)YMA[yma]A["I",ymp]|4
policy.number 20 FREE L $(YM)YMA[yma]A["I",ymp]|6
pri.iplan.yn 1 YN L VAL=IF{ins.plan=@pri.ins.plan "Y";ins.plan "N"}
subs.city.state.zip 35 FREE L VAL=IF{L(IF{@subscriber.urn^URN,@city[URN]^XX XX}^ZMSC
VAL=)+L(IF{@state[URN]^XX ", "_XX]}_IF{@zip[URN]^XX ",
VAL= "_XX}^ZMSSZ)>35 ZMSC$(35-L(ZMSSZ))_ZMSSZ;ZMSC_
VAL=ZMSSZ}
subs.contract.employer 30 FREE L MIS.EMPLR $(YM)YMA[yma]A["I",ymp]S|6
subs.emp.status 10 FREE L MIS.EMP.STATUS VAL=@emp.status[@subscriber.urn]
subs.employer 30 FREE L MIS.EMPLR VAL=IF{@subscriber.urn @MRI.DRC.employer[@MC.MEM.mpi[@
VAL=subscriber.urn]];@subscriber.urn=@urn @ee.employer
VAL=}
subs.employer.ct.rpt.fld 30 FREE L MIS.EMPLR VAL=@MRI.DRC.employer[@MC.MEM.mpi[@subscriber.urn]]
subs.iplan.exp.date 8 DATE L $(YM)YMA[yma]A["I",ymp]S|3
subs.iplan.grp.number 15 FREE L $(YM)YMA[yma]A["I",ymp]S|4
subs.iplan.renew.date 8 DATE L $(YM)YMA[yma]A["I",ymp]S|5
subs.iplan.type 10 FREE L $(YM)YMA[yma]A["I",ymp]S|0
subs.mem.number 25 FREE L VAL=@member.number[@subscriber.urn,ins.plan]
subs.name 30 NAME L VAL=@name[@subscriber.urn]
subs.street 30 FREE L VAL=@street[@subscriber.urn]
subs.street2 30 FREE L VAL=@street2[@subscriber.urn]
subscriber.relation 10 FREE L MIS.RELAT $(YM)YMA[yma]A["I",ymp]|2
subscriber.urn 25 URN L MC.MEM $(YM)YMA[yma]A["I",ymp]|1
Ì € i 2
ins.plan.cds.queries
[urn,ins.plan, ins.cd.query]
$(YM)YMA[yma]A["I",ymp]CD["CD",ggv]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ins.cd.query 10 FREE L MIS.QUERY ggv
ins.cd.display 90 FREE L VAL=@MIS.QUERY.text_" "_@ins.cd.response
ins.cd.response 75 QRY.RESP L $(YM)YMA[yma]A["I",ymp]CD["CD",ggv]|0
ins.cd.yn.comment 70 QRY.RESP L $(YM)YMA[yma]A["I",ymp]CD["CD",ggv]|5
Ì € i 2
insurance.plan.eff.dt.q
[urn,ins.plan, ins.effective.date]
$(YM)YMA[yma]A["I",ymp]EDT[ymaEQ]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ins.effective.date 8 DATE L ymaEQ
benefit.effective 10 FREE L MIS.INS.BENE $(YM)YMA[yma]A["I",ymp]EDT[ymaEQ]|3
cg.effective 10 URN L MC.CARE.GRP $(YM)YMA[yma]A["I",ymp]EDT[ymaEQ]|1
last.edit.date 8 DATE L $(YM)YMA[yma]A["I",ymp]EDT[ymaEQ]|5
obgyn.pcp.effective 10 FREE L MC.PROV.CON $(YM)YMA[yma]A["I",ymp]EDT[ymaEQ]|4
pcp.effective 10 FREE L MC.PROV.CON $(YM)YMA[yma]A["I",ymp]EDT[ymaEQ]|0
status.effective 9 CHOICE L $(YM)YMA[yma]A["I",ymp]EDT[ymaEQ]|2
Ì € i 2
mem.cd.screen.queries
[urn, mem.cd.query]
$(YM)YMA[yma]A["CD",ggv]
Field Name Len Dat Typ J DPM Offset/Local/VAL
mem.cd.query 10 FREE L MIS.QUERY ggv
mem.cd.display 90 FREE L VAL=@MIS.QUERY.text_" "_@mem.cd.response
mem.cd.response 75 QRY.RESP L $(YM)YMA[yma]A["CD",ggv]|0
mem.cd.yn.comment 70 QRY.RESP L $(YM)YMA[yma]A["CD",ggv]|5
Ì € i 2
merged.from.members
[urn, merged.from.urn]
$(YM)YMA[yma]A["XM",ymaXM]
Field Name Len Dat Typ J DPM Offset/Local/VAL
merged.from.urn 25 URN L MC.MEM ymaXM
merged.time 10 INT R $(YM)YMA[yma]A["XM",ymaXM]|0
Ì € i 2
merged.from.mri
[urn, mri.mf.seq.n]
$(YM)YMA[yma]A["MF",ymfs]
Field Name Len Dat Typ J DPM Offset/Local/VAL
mri.mf.seq.n 2 PINT R ymfs
mri.mf.member 25 URN L MC.MEM $(YM)YMA[yma]A["MF",ymfs]|1
mri.mf.mpi 20 FREE L $(YM)YMA[yma]A["MF",ymfs]|0
Ì € i 2
merged.transactions.det
[urn,merge.txn.type,merge.txn.urn.ptr,
$(YM)YMA[yma]A["MERGE",ymaX1,ymaX2]D
Field Name Len Dat Typ J DPM Offset/Local/VAL
merged.txn.detail 100 FREE L $(YM)YMA[yma]A["MERGE",ymaX1,ymaX2]D
Ì € i 2
mis.insurance
[urn, mis.ins]
$(YM)YMA[yma]A["IM",ggm]
Field Name Len Dat Typ J DPM Offset/Local/VAL
mis.ins 10 FREE L MIS.INS ggm
mi.benefit 10 FREE L MIS.INS.BENE $(YM)YMA[yma]A["IM",ggm]|7
mi.care.group 10 URN L MC.CARE.GRP $(YM)YMA[yma]A["IM",ggm]|5
mi.cov.number 20 FREE L $(YM)YMA[yma]A["IM",ggm]|13
mi.eff.date 8 DATE L $(YM)YMA[yma]A["IM",ggm]|9
mi.emp.loc 30 FREE L $(YM)YMA[yma]A["IM",ggm]I2|1
mi.employer 10 FREE L MIS.EMPLR $(YM)YMA[yma]A["IM",ggm]I2|0
mi.exp.date 8 DATE L $(YM)YMA[yma]A["IM",ggm]|10
mi.group.name 30 FREE L $(YM)YMA[yma]A["IM",ggm]|14
mi.group.number 15 FREE L $(YM)YMA[yma]A["IM",ggm]|11
mi.ins.plan.status 9 CHOICE L $(YM)YMA[yma]A["IM",ggm]|2
mi.ins.plan.status.date 8 DATE L $(YM)YMA[yma]A["IM",ggm]|12
mi.ins.status.last.verif 8 DATE L $(YM)YMA[yma]A["IM",ggm]|3
mi.mri.subs.urn 35 URN L MRI.SUBSCRIBER $(YM)YMA[yma]A["IM",ggm]|8
mi.pcp 10 FREE L MC.PROV.CON $(YM)YMA[yma]A["IM",ggm]|4
mi.policy.number 20 FREE L $(YM)YMA[yma]A["IM",ggm]|6
mi.subs.cov.number 20 FREE L VAL=IF{@mpi[@mi.subscriber.urn] @MRI.DRC.insurance.cov
VAL=.no[@mpi[@mi.subscriber.urn]];@MRI.SUBSCRIBER.subs
VAL=.insurance.cov.no[@mi.mri.subs.urn[@mi.subscriber.
VAL=urn,mis.ins],mis.ins]}
mi.subs.eff.date 8 DATE L VAL=@mi.eff.date[@mi.subscriber.urn,mis.ins]
mi.subs.emp.status 10 FREE L MIS.EMP.STATUS VAL=@emp.status[@mi.subscriber.urn]
mi.subs.employer 10 FREE L MIS.EMPLR VAL=IF{@mpi[@mi.subscriber.urn] @MRI.DRC.employer[@mpi
VAL=[@mi.subscriber.urn]];@MRI.SUBSCRIBER.subs.emp.nam
VAL=e[@mi.mri.subs.urn[@mi.subscriber.urn,mis.ins],mis
VAL=.ins]}
mi.subs.exp.date 8 DATE L VAL=@mi.exp.date[@mi.subscriber.urn,mis.ins]
mi.subs.group.name 30 FREE L VAL=@mi.group.name[@mi.subscriber.urn,mis.ins]
mi.subs.group.number 15 FREE L VAL=@mi.group.number[@mi.subscriber.urn,mis.ins]
mi.subs.ins.last.verif 8 DATE L VAL=@mi.ins.status.last.verif[@mi.subscriber.urn,mis.i
VAL=ns]
mi.subs.ins.plan.status 9 CHOICE L VAL=@mi.ins.plan.status[@mi.subscriber.urn,mis.ins]
mi.subs.ins.status.date 8 DATE L $(YM)YMA[yma]A["IM",ggm]I2|2
mi.subs.name 30 FREE L VAL=@name[@mi.subscriber.urn]
mi.subs.pol.number 20 FREE L VAL=@mi.policy.number[@mi.subscriber.urn,mis.ins]
mi.subs.relation 10 FREE L MIS.RELAT $(YM)YMA[yma]A["IM",ggm]|1
mi.subscriber.urn 25 URN L MC.MEM $(YM)YMA[yma]A["IM",ggm]|0
mis.insurance.cd.screen 15 FREE L MIS.SCREEN VAL=@MC.MEM.PLAN.insurance.cd.screen[MC.MEM.PLAN.mappe
VAL=d.x[@mis.ins]]
Ì € i 2
mis.ins.cds.queries
[urn,mis.ins, mis.ins.cd.query]
$(YM)YMA[yma]A["IM",ggm]CD[ggv]
Field Name Len Dat Typ J DPM Offset/Local/VAL
mis.ins.cd.query 10 FREE L MIS.QUERY ggv
mis.ins.cd.display 90 FREE L VAL=@MIS.QUERY.text_" "_@mis.ins.cd.response
mis.ins.cd.response 75 QRY.RESP L $(YM)YMA[yma]A["IM",ggm]CD[ggv]|0
mis.ins.cd.yn.comment 70 QRY.RESP L $(YM)YMA[yma]A["IM",ggm]CD[ggv]|5
Ì € i 2
reminders
[urn, reminder.number]
$(YM)YMA[yma]R[ymaRN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
reminder.number 3 PINT R ymaRN
rem.entered.date 8 DATE L $(YM)YMA[yma]R[ymaRN]|4
rem.entered.time 4 HHMM L $(YM)YMA[yma]R[ymaRN]|5
rem.entered.user 10 FREE L MIS.USER $(YM)YMA[yma]R[ymaRN]|6
rem.resolved.date 8 DATE L $(YM)YMA[yma]R[ymaRN]|7
rem.resolved.time 4 HHMM L $(YM)YMA[yma]R[ymaRN]|8
rem.resolved.user 10 FREE L MIS.USER $(YM)YMA[yma]R[ymaRN]|9
reminder.category 10 FREE L MC.REM.CAT $(YM)YMA[yma]R[ymaRN]|10
reminder.date 8 DATE L $(YM)YMA[yma]R[ymaRN]|0
reminder.insurance 10 FREE L MC.MEM.PLAN $(YM)YMA[yma]R[ymaRN]|2
reminder.mis.insurance 10 FREE L MIS.INS $(YM)YMA[yma]R[ymaRN]|11
reminder.status 10 CHOICE L $(YM)YMA[yma]R[ymaRN]|3
reminder.time 4 HHMM L $(YM)YMA[yma]R[ymaRN]|1
Ì € i 2
reminder.text
[urn,reminder.number, rem.text.urn]
$(YM)YMA[yma]R[ymaRN]T[ymaTX]
Field Name Len Dat Typ J DPM Offset/Local/VAL
rem.text.urn 3 URN L ymaTX
rem.text 79 TEXT L $(YM)YMA[yma]R[ymaRN]T[ymaTX]
Ì € i 2
services.perf.by.month
[urn, services.month,services.mon.svc.group]
$(YM)YMA[yma]MP[yamon,gsh]
Field Name Len Dat Typ J DPM Offset/Local/VAL
services.month 8 DATE L yamon
services.mon.svc.group 10 FREE L MIS.SVC.GRP gsh
services.mon.oop.amt 10 MONEY R $(YM)YMA[yma]MP[yamon,gsh]|2
services.mon.pri.qty 5 INT R $(YM)YMA[yma]MP[yamon,gsh]|3
services.mon.qty 5 INT R $(YM)YMA[yma]MP[yamon,gsh]|0
services.mon.reimb.amt 10 MONEY R $(YM)YMA[yma]MP[yamon,gsh]|1
Ì € i 2
services.perf.by.mon.spec
[urn,services.month,services.mon.svc.group, services.mon.spec]
$(YM)YMA[yma]MP[yamon,gsh]S[gsd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
services.mon.spec 10 FREE L MIS.ABS.SVC gsd
services.mon.spec.oop 10 MONEY R $(YM)YMA[yma]MP[yamon,gsh]S[gsd]|2
services.mon.spec.qty 5 INT R $(YM)YMA[yma]MP[yamon,gsh]S[gsd]|0
services.mon.spec.reimb 10 MONEY R $(YM)YMA[yma]MP[yamon,gsh]S[gsd]|1
Ì € i 2
services.performed
[urn, services.date,services.group]
$(YM)YMA[yma]SP[ymaPD,gsh]
Field Name Len Dat Typ J DPM Offset/Local/VAL
services.date 8 DATE L ymaPD
services.group 10 FREE L MIS.SVC.GRP gsh
services.oop.amt 10 MONEY R $(YM)YMA[yma]SP[ymaPD,gsh]|2
services.pri.qty 5 INT R $(YM)YMA[yma]SP[ymaPD,gsh]|3
services.qty 5 INT R $(YM)YMA[yma]SP[ymaPD,gsh]|0
services.reimb.amt 10 MONEY R $(YM)YMA[yma]SP[ymaPD,gsh]|1
Ì € i 2
services.performed.spec
[urn,services.date,services.group, services.spec]
$(YM)YMA[yma]SP[ymaPD,gsh]S[gsd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
services.spec 10 FREE L MIS.ABS.SVC gsd
services.spec.oop.amt 10 MONEY R $(YM)YMA[yma]SP[ymaPD,gsh]S[gsd]|2
services.spec.qty 5 INT R $(YM)YMA[yma]SP[ymaPD,gsh]S[gsd]|0
services.spec.reimb.amt 10 MONEY R $(YM)YMA[yma]SP[ymaPD,gsh]S[gsd]|1
Ì € i 2
tasks
[urn, task.number]
$(YM)YMA[yma]CST[ymaTN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
task.number 3 PINT R ymaTN
task.category 10 FREE L MC.REM.CAT $(YM)YMA[yma]CST[ymaTN]|10
task.closed.date 8 DATE L $(YM)YMA[yma]CST[ymaTN]|7
task.closed.time 4 HHMM L $(YM)YMA[yma]CST[ymaTN]|8
task.closed.user 10 FREE L MIS.USER $(YM)YMA[yma]CST[ymaTN]|9
task.date 8 DATE L $(YM)YMA[yma]CST[ymaTN]|0
task.entered.date 8 DATE L $(YM)YMA[yma]CST[ymaTN]|4
task.entered.time 4 HHMM L $(YM)YMA[yma]CST[ymaTN]|5
task.entered.user 10 FREE L MIS.USER $(YM)YMA[yma]CST[ymaTN]|6
task.insurance 10 FREE L MC.MEM.PLAN $(YM)YMA[yma]CST[ymaTN]|2
task.status 10 CHOICE L $(YM)YMA[yma]CST[ymaTN]|3
task.time 4 HHMM L $(YM)YMA[yma]CST[ymaTN]|1
Ì € i 2
task.text
[urn,task.number, task.text.urn]
$(YM)YMA[yma]CST[ymaTN]T[ymaTX]
Field Name Len Dat Typ J DPM Offset/Local/VAL
task.text.urn 3 URN L ymaTX
task.text.line 79 TEXT L $(YM)YMA[yma]CST[ymaTN]T[ymaTX]
Ì € i 2
transactions
[urn, txn.date,txn.time,txn.queue]
$(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]
Field Name Len Dat Typ J DPM Offset/Local/VAL
txn.date 8 DATE L ymaTD
txn.time 4 HHMM L ymaTT
txn.queue 2 PINT R ymaTQ
txn.benefit.year 4 YEAR L $(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]B|0
txn.ded.in.amt 10 MONEY R $(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]B|1
txn.ded.in.bal 10 MONEY R $(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]B|7
txn.ded.out.amt 10 MONEY R $(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]B|2
txn.ded.out.bal 10 MONEY R $(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]B|8
txn.effective.date 8 DATE L $(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]|6
txn.ins 10 FREE L MC.MEM.PLAN $(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]|4
txn.new.value 45 FREE L $(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]|2
txn.normal.reversing 2 FREE L $(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]|7
txn.old.value 45 FREE L $(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]|1
txn.oop.in.amt 10 MONEY R $(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]B|3
txn.oop.in.bal 10 MONEY R $(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]B|9
txn.oop.out.amt 10 MONEY R $(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]B|4
txn.oop.out.bal 10 MONEY R $(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]B|10
txn.pointer 10 PINT R $(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]|5
txn.reimb.in.amt 10 MONEY R $(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]B|5
txn.reimb.in.bal 10 MONEY R $(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]B|11
txn.reimb.out.amt 10 MONEY R $(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]B|6
txn.reimb.out.bal 10 MONEY R $(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]B|12
txn.type 10 FREE L MC.TXN.TYPE $(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]|0
txn.user 10 FREE L MIS.USER $(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]|3
Ì € i 2
transaction.eff.dt.vector
[urn,txn.date,txn.time,txn.queue, txn.ins.eff.date]
$(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]EDT[ymaEQ]
Field Name Len Dat Typ J DPM Offset/Local/VAL
txn.ins.eff.date 8 DATE L ymaEQ
txn.ins.benefit 10 FREE L MIS.INS.BENE $(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]EDT[ymaEQ]|3
txn.ins.cg 10 URN L MC.CARE.GRP $(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]EDT[ymaEQ]|1
txn.ins.pcp 10 FREE L MC.PROV.CON $(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]EDT[ymaEQ]|0
txn.ins.status 10 CHOICE L $(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]EDT[ymaEQ]|2
Ì € i 2
transaction.text
[urn,txn.date,txn.time,txn.queue, txn.text.urn]
$(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]T[ymaTX]
Field Name Len Dat Typ J DPM Offset/Local/VAL
txn.text.urn 3 URN L ymaTX
txn.text 79 TEXT L $(YM)YMA[yma]T[ymaTD,ymaTT,ymaTQ]T[ymaTX]
Index Files Subscripts/Physical Base
alt.database.mpi.x [alt.mri.database,alt.mri.urn] = urn
?(YM)YMAEA[gn,ea]
ins.plan.x [ins.plan,urn]
?(YM)YMAI[ymp,yma]
ins.policy.number.x [policy.number,ins.plan,urn]
?(YM)YMAPN[ymaPN,ymp,yma]
iplan.exp.date.x [ins.plan,ins.plan.exp.date,subscriber.urn,urn]
?(YM)YMAEX[ymp,ymaXD,ymaS,yma]
mem.audit.date.x [last.mc.edit,urn]
?(YM)YMAAD[ymaED,yma]
mem.audit.x [txn.date,txn.time,txn.queue,ins.edit.type,urn]
?(YM)YMAAT[ymaTD,ymaTT,ymaTQ,ymaT,yma]
mem.ins.audit.date.x [last.mc.ins.edit,urn]
?(YM)YMAAI[ymaEI,yma]
member.id.x [member.id,urn]
?(YM)YMAID[ymaID,yma]
member.number.base.x [member.number.base,urn]
?(YM)YMAMB[ymaMB,yma]
member.number.x [member.number,urn]
?(YM)YMAM[ymaM,yma]
merge.history.x [merge.from.urn,merge.seconds,merge.type,merge.from.or.to] = merge.to.urn
?(YM)YMAMHX[yma,ymaMX,ymaMT,ymaMF]
merged.id.x [member.id,urn]
?(YM)YMAMID[ymaID,yma]
merged.name.x [name,urn]
?(YM)YMAMIDN[ymaN,yma]
mis.ins.exp.date.x [mis.ins,mi.exp.date,mi.subscriber.urn,urn]
?(YM)YMAEXMI[ggm,ymaXD,ymas,yma]
mis.ins.pcp.x [mi.pcp,mis.ins,urn]
?(YM)YMAPMI[ggg,ggm,yma]
mis.ins.pol.num.x [mi.policy.number,mis.ins,urn]
?(YM)YMAPNMI[ymaPN,ggm,yma]
mis.ins.subs.pol.num.x [mi.subs.pol.number,urn]
?(YM)YMASPN[ymSPN,yma]
mis.ins.x [mis.ins,urn]
?(YM)YMAMI[ggm,yma]
mri.sub.x [mri.subscriber,mri.subscriber.db] = urn
?(YM)YMRS[eaSB,gn]
mri.urn.x [mpi] = urn
?(YM)YMAMU[ea]
name.x [name,urn]
?(YM)YMAN[ymaN,yma]
pcp.ins.x [pcp,ins.plan,urn]
?(YM)YMAPI[ggg,ymp,yma]
pcp.name.x [pcp,name,urn]
?(YM)YMAPCN[ggg,ymaN,yma]
pcp.x [pcp,urn]
?(YM)YMAPC[ggg,yma]
reminder.category.x [reminder.category,reminder.date,urn,reminder.number]
?(YM)YMARC[ysc,ymaRD,yma,ymaRN]
reminder.open.x [reminder.date,reminder.time,urn,reminder.number]
?(YM)YMARO[ymaRD,ymaRT,yma,ymaRN]
reminder.x [reminder.date,reminder.time,urn,reminder.number]
?(YM)YMAR[ymaRD,ymaRT,yma,ymaRN]
soc.sec.x [soc.sec.num,urn]
?(YM)YMASS[ymaSS,yma]
subscriber.number.x [subs.mem.number,urn]
?(YM)YMASM[ymaSM,yma]
subscriber.x [subscriber,urn]
?(YM)YMAS[ymaS,yma]
task.category.x [task.category,task.date,urn,task.number]
?(YM)YMATC[ysc,ymaTD,yma,ymaTN]
task.open.x [task.date,task.time,urn,task.number]
?(YM)YMATO[ymaTD,ymaTT,yma,ymaTN]
task.x [task.date,task.time,urn,task.number]
?(YM)YMATX[ymaTD,ymaTT,yma,ymaTN]
urn.x [urn]
?(YM)YMU[yma]
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |